CREATE TABLE [dbo].[tb_FechasDeLicencias]
(
[IdFechaDeLicencia] [int] NOT NULL IDENTITY(1, 1),
[FechaDesde] [datetime] NOT NULL,
[FechaHasta] [datetime] NOT NULL,
[Licencia] [int] NOT NULL,
[Descontar] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_FechasDeLicencias] ADD CONSTRAINT [PK_tb_FechasDeLicencias] PRIMARY KEY CLUSTERED  ([IdFechaDeLicencia]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_FechasDeLicencias] WITH NOCHECK ADD CONSTRAINT [FK_tb_FechasDeLicencias_tb_Licencias] FOREIGN KEY ([Licencia]) REFERENCES [dbo].[tb_Licencias] ([idLicencia])
GO
